Upstate Police Chief Resigns After Using The 'N-Word'